{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>totalprice</th>\n",
       "      <th>unitprice</th>\n",
       "      <th>position</th>\n",
       "      <th>rooms</th>\n",
       "      <th>size</th>\n",
       "      <th>orientation</th>\n",
       "      <th>decoration</th>\n",
       "      <th>elevator</th>\n",
       "      <th>area</th>\n",
       "      <th>height</th>\n",
       "      <th>year</th>\n",
       "      <th>buildtype</th>\n",
       "      <th>follow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>920.0</td>\n",
       "      <td>77188</td>\n",
       "      <td>天悦龙庭二期</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>119.19</td>\n",
       "      <td>西南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>宝安中心</td>\n",
       "      <td>中</td>\n",
       "      <td>2005</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>340.0</td>\n",
       "      <td>51909</td>\n",
       "      <td>大益广场</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>65.50</td>\n",
       "      <td>西南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>西乡</td>\n",
       "      <td>低</td>\n",
       "      <td>2002</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>660.0</td>\n",
       "      <td>73884</td>\n",
       "      <td>中熙香缇湾</td>\n",
       "      <td>4室2厅</td>\n",
       "      <td>89.33</td>\n",
       "      <td>西南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>西乡</td>\n",
       "      <td>中</td>\n",
       "      <td>2009</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1150.0</td>\n",
       "      <td>76657</td>\n",
       "      <td>深业新岸线三期</td>\n",
       "      <td>4室1厅</td>\n",
       "      <td>150.02</td>\n",
       "      <td>东南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>宝安中心</td>\n",
       "      <td>中</td>\n",
       "      <td>2008</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>570.0</td>\n",
       "      <td>52127</td>\n",
       "      <td>碧海富通城一期</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>109.35</td>\n",
       "      <td>南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>碧海</td>\n",
       "      <td>中</td>\n",
       "      <td>2006</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   totalprice  unitprice  position rooms    size orientation decoration  \\\n",
       "0       920.0      77188   天悦龙庭二期   3室2厅  119.19          西南         精装   \n",
       "1       340.0      51909     大益广场   2室2厅   65.50          西南         精装   \n",
       "2       660.0      73884    中熙香缇湾   4室2厅   89.33          西南         精装   \n",
       "3      1150.0      76657  深业新岸线三期   4室1厅  150.02          东南         精装   \n",
       "4       570.0      52127  碧海富通城一期   3室2厅  109.35           南         精装   \n",
       "\n",
       "  elevator  area height  year buildtype  follow  \n",
       "0      有电梯  宝安中心      中  2005        塔楼      13  \n",
       "1      有电梯    西乡      低  2002      板塔结合     160  \n",
       "2      有电梯    西乡      中  2009      板塔结合     226  \n",
       "3      有电梯  宝安中心      中  2008        塔楼      29  \n",
       "4      有电梯    碧海      中  2006      板塔结合      54  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "house_baoan = pd.read_excel('house_baoan.xls', index_col=None)\n",
    "house_baoan.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>totalprice</th>\n",
       "      <th>unitprice</th>\n",
       "      <th>position</th>\n",
       "      <th>rooms</th>\n",
       "      <th>size</th>\n",
       "      <th>orientation</th>\n",
       "      <th>decoration</th>\n",
       "      <th>elevator</th>\n",
       "      <th>area</th>\n",
       "      <th>height</th>\n",
       "      <th>year</th>\n",
       "      <th>buildtype</th>\n",
       "      <th>follow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>588.0</td>\n",
       "      <td>66090</td>\n",
       "      <td>金海湾花园</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>88.97</td>\n",
       "      <td>东南</td>\n",
       "      <td>简装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>上下沙</td>\n",
       "      <td>低</td>\n",
       "      <td>2001</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>500.0</td>\n",
       "      <td>66086</td>\n",
       "      <td>益田村</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>75.66</td>\n",
       "      <td>南</td>\n",
       "      <td>其他</td>\n",
       "      <td>无电梯</td>\n",
       "      <td>石厦</td>\n",
       "      <td>中</td>\n",
       "      <td>1995</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>565.0</td>\n",
       "      <td>58483</td>\n",
       "      <td>景新花园</td>\n",
       "      <td>4室2厅</td>\n",
       "      <td>96.61</td>\n",
       "      <td>南</td>\n",
       "      <td>简装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>景田</td>\n",
       "      <td>低</td>\n",
       "      <td>1996</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>425.0</td>\n",
       "      <td>54481</td>\n",
       "      <td>众孚大厦</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>78.01</td>\n",
       "      <td>南</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>石厦</td>\n",
       "      <td>高</td>\n",
       "      <td>2002</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>428.0</td>\n",
       "      <td>53056</td>\n",
       "      <td>嘉洲豪园</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>80.67</td>\n",
       "      <td>东北</td>\n",
       "      <td>简装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>新洲</td>\n",
       "      <td>低</td>\n",
       "      <td>2001</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>229</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   totalprice  unitprice position rooms   size orientation decoration  \\\n",
       "0       588.0      66090   金海湾花园   2室2厅  88.97          东南         简装   \n",
       "1       500.0      66086     益田村   3室2厅  75.66           南         其他   \n",
       "2       565.0      58483    景新花园   4室2厅  96.61           南         简装   \n",
       "3       425.0      54481    众孚大厦   2室2厅  78.01           南         其他   \n",
       "4       428.0      53056    嘉洲豪园   2室1厅  80.67          东北         简装   \n",
       "\n",
       "  elevator area height  year buildtype  follow  \n",
       "0      有电梯  上下沙      低  2001      板塔结合     156  \n",
       "1      无电梯   石厦      中  1995      板塔结合      87  \n",
       "2      有电梯   景田      低  1996        塔楼      96  \n",
       "3      有电梯   石厦      高  2002      板塔结合     343  \n",
       "4      有电梯   新洲      低  2001      板塔结合     229  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "house_futian = pd.read_excel('house_futian.xls', index_col=None)\n",
    "house_futian.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>totalprice</th>\n",
       "      <th>unitprice</th>\n",
       "      <th>position</th>\n",
       "      <th>rooms</th>\n",
       "      <th>size</th>\n",
       "      <th>orientation</th>\n",
       "      <th>decoration</th>\n",
       "      <th>elevator</th>\n",
       "      <th>area</th>\n",
       "      <th>height</th>\n",
       "      <th>year</th>\n",
       "      <th>buildtype</th>\n",
       "      <th>follow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>335.0</td>\n",
       "      <td>38837</td>\n",
       "      <td>中海康城国际一期</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>86.26</td>\n",
       "      <td>西北</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>大运新城</td>\n",
       "      <td>高</td>\n",
       "      <td>2011</td>\n",
       "      <td>板楼</td>\n",
       "      <td>221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300.0</td>\n",
       "      <td>41380</td>\n",
       "      <td>中海康城花园二期</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>72.50</td>\n",
       "      <td>北</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>大运新城</td>\n",
       "      <td>低</td>\n",
       "      <td>2011</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>485.0</td>\n",
       "      <td>56560</td>\n",
       "      <td>星河时代</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>85.75</td>\n",
       "      <td>南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>大运新城</td>\n",
       "      <td>低</td>\n",
       "      <td>2012</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>1197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>189.0</td>\n",
       "      <td>34327</td>\n",
       "      <td>德福花园</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>55.06</td>\n",
       "      <td>西南</td>\n",
       "      <td>其他</td>\n",
       "      <td>无电梯</td>\n",
       "      <td>布吉街</td>\n",
       "      <td>高</td>\n",
       "      <td>1998</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>650.0</td>\n",
       "      <td>43724</td>\n",
       "      <td>万科城四期</td>\n",
       "      <td>5室2厅</td>\n",
       "      <td>148.66</td>\n",
       "      <td>南</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>坂田</td>\n",
       "      <td>低</td>\n",
       "      <td>2008</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   totalprice  unitprice   position rooms    size orientation decoration  \\\n",
       "0       335.0      38837  中海康城国际一期   3室1厅   86.26          西北         其他   \n",
       "1       300.0      41380  中海康城花园二期   2室1厅   72.50           北         精装   \n",
       "2       485.0      56560      星河时代   3室1厅   85.75           南         精装   \n",
       "3       189.0      34327      德福花园   2室2厅   55.06          西南         其他   \n",
       "4       650.0      43724     万科城四期   5室2厅  148.66           南         其他   \n",
       "\n",
       "  elevator  area height  year buildtype  follow  \n",
       "0      有电梯  大运新城      高  2011        板楼     221  \n",
       "1      有电梯  大运新城      低  2011        塔楼     221  \n",
       "2      有电梯  大运新城      低  2012        塔楼    1197  \n",
       "3      无电梯   布吉街      高  1998      板塔结合     542  \n",
       "4      有电梯    坂田      低  2008      板塔结合     144  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "house_longgang = pd.read_excel('house_longgang.xls', index_col=None)\n",
    "house_longgang.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>totalprice</th>\n",
       "      <th>unitprice</th>\n",
       "      <th>position</th>\n",
       "      <th>rooms</th>\n",
       "      <th>size</th>\n",
       "      <th>orientation</th>\n",
       "      <th>decoration</th>\n",
       "      <th>elevator</th>\n",
       "      <th>area</th>\n",
       "      <th>height</th>\n",
       "      <th>year</th>\n",
       "      <th>buildtype</th>\n",
       "      <th>follow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>376</td>\n",
       "      <td>55246</td>\n",
       "      <td>潜龙鑫茂花园B区</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>68.06</td>\n",
       "      <td>北</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>民治</td>\n",
       "      <td>高</td>\n",
       "      <td>2006</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>350</td>\n",
       "      <td>43783</td>\n",
       "      <td>劲力城市明珠</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>79.94</td>\n",
       "      <td>东南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>龙华中心</td>\n",
       "      <td>中</td>\n",
       "      <td>2005</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>670</td>\n",
       "      <td>75248</td>\n",
       "      <td>万科金域华府</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>89.04</td>\n",
       "      <td>西南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>深圳北站</td>\n",
       "      <td>高</td>\n",
       "      <td>2010</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>670</td>\n",
       "      <td>75256</td>\n",
       "      <td>万科金域华府</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>89.03</td>\n",
       "      <td>西南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>深圳北站</td>\n",
       "      <td>中</td>\n",
       "      <td>2010</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>560</td>\n",
       "      <td>40984</td>\n",
       "      <td>锦绣江南三期</td>\n",
       "      <td>4室1厅</td>\n",
       "      <td>136.64</td>\n",
       "      <td>东南</td>\n",
       "      <td>简装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>深圳北站</td>\n",
       "      <td>低</td>\n",
       "      <td>2005</td>\n",
       "      <td>板楼</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   totalprice  unitprice   position rooms    size orientation decoration  \\\n",
       "0         376      55246  潜龙鑫茂花园B区   2室2厅   68.06           北         精装   \n",
       "1         350      43783    劲力城市明珠   3室1厅   79.94          东南         精装   \n",
       "2         670      75248    万科金域华府   3室2厅   89.04          西南         精装   \n",
       "3         670      75256    万科金域华府   3室2厅   89.03          西南         精装   \n",
       "4         560      40984    锦绣江南三期   4室1厅  136.64          东南         简装   \n",
       "\n",
       "  elevator  area height  year buildtype  follow  \n",
       "0      有电梯    民治      高  2006      板塔结合      66  \n",
       "1      有电梯  龙华中心      中  2005      板塔结合      60  \n",
       "2      有电梯  深圳北站      高  2010      板塔结合     365  \n",
       "3      有电梯  深圳北站      中  2010      板塔结合     276  \n",
       "4      有电梯  深圳北站      低  2005        板楼      12  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "house_longhua = pd.read_excel('house_longhua.xls', index_col=None)\n",
    "house_longhua.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>totalprice</th>\n",
       "      <th>unitprice</th>\n",
       "      <th>position</th>\n",
       "      <th>rooms</th>\n",
       "      <th>size</th>\n",
       "      <th>orientation</th>\n",
       "      <th>decoration</th>\n",
       "      <th>elevator</th>\n",
       "      <th>area</th>\n",
       "      <th>height</th>\n",
       "      <th>year</th>\n",
       "      <th>buildtype</th>\n",
       "      <th>follow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>246.0</td>\n",
       "      <td>47427</td>\n",
       "      <td>铂金时代罗湖</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>51.87</td>\n",
       "      <td>北</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>罗湖口岸</td>\n",
       "      <td>低</td>\n",
       "      <td>2008</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>220.0</td>\n",
       "      <td>57819</td>\n",
       "      <td>新天地名居</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>38.05</td>\n",
       "      <td>北</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>黄贝岭</td>\n",
       "      <td>中</td>\n",
       "      <td>2005</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>372.0</td>\n",
       "      <td>54165</td>\n",
       "      <td>翠盈嘉园</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>68.68</td>\n",
       "      <td>东 北</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>洪湖</td>\n",
       "      <td>中</td>\n",
       "      <td>2002</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>640.0</td>\n",
       "      <td>66841</td>\n",
       "      <td>缤纷时代家园</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>95.75</td>\n",
       "      <td>东南 南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>螺岭</td>\n",
       "      <td>高</td>\n",
       "      <td>2004</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>355.0</td>\n",
       "      <td>46448</td>\n",
       "      <td>玉雅居</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>76.43</td>\n",
       "      <td>南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>莲塘</td>\n",
       "      <td>中</td>\n",
       "      <td>1998</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   totalprice  unitprice position rooms   size orientation decoration  \\\n",
       "0       246.0      47427  铂金时代罗湖   2室1厅  51.87           北         精装   \n",
       "1       220.0      57819   新天地名居   1室1厅  38.05           北         精装   \n",
       "2       372.0      54165    翠盈嘉园   2室1厅  68.68         东 北         精装   \n",
       "3       640.0      66841  缤纷时代家园   3室2厅  95.75        东南 南         精装   \n",
       "4       355.0      46448     玉雅居   3室1厅  76.43           南         精装   \n",
       "\n",
       "  elevator  area height  year buildtype  follow  \n",
       "0      有电梯  罗湖口岸      低  2008      板塔结合     276  \n",
       "1      有电梯   黄贝岭      中  2005      板塔结合     112  \n",
       "2      有电梯    洪湖      中  2002      板塔结合      57  \n",
       "3      有电梯    螺岭      高  2004      板塔结合     183  \n",
       "4      有电梯    莲塘      中  1998      板塔结合      39  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "house_luohu = pd.read_excel('house_luohu.xls', index_col=None)\n",
    "house_luohu.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>totalprice</th>\n",
       "      <th>unitprice</th>\n",
       "      <th>position</th>\n",
       "      <th>rooms</th>\n",
       "      <th>size</th>\n",
       "      <th>orientation</th>\n",
       "      <th>decoration</th>\n",
       "      <th>elevator</th>\n",
       "      <th>area</th>\n",
       "      <th>height</th>\n",
       "      <th>year</th>\n",
       "      <th>buildtype</th>\n",
       "      <th>follow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1130.0</td>\n",
       "      <td>84398</td>\n",
       "      <td>海月花园二期</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>133.89</td>\n",
       "      <td>南 北</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>蛇口</td>\n",
       "      <td>高</td>\n",
       "      <td>2003</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>785.0</td>\n",
       "      <td>71749</td>\n",
       "      <td>缤纷假日豪园</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>109.41</td>\n",
       "      <td>东南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>南山中心</td>\n",
       "      <td>低</td>\n",
       "      <td>2001</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>305.0</td>\n",
       "      <td>67078</td>\n",
       "      <td>美丽湾国际公寓</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>45.47</td>\n",
       "      <td>北</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>南山中心</td>\n",
       "      <td>高</td>\n",
       "      <td>2007</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500.0</td>\n",
       "      <td>78004</td>\n",
       "      <td>向南瑞峰花园</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>64.10</td>\n",
       "      <td>西</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>南山中心</td>\n",
       "      <td>低</td>\n",
       "      <td>2011</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>445.0</td>\n",
       "      <td>62047</td>\n",
       "      <td>海典居</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>71.72</td>\n",
       "      <td>东</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>南山中心</td>\n",
       "      <td>中</td>\n",
       "      <td>1999</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   totalprice  unitprice  position rooms    size orientation decoration  \\\n",
       "0      1130.0      84398   海月花园二期   3室2厅  133.89         南 北         其他   \n",
       "1       785.0      71749   缤纷假日豪园   3室2厅  109.41          东南         精装   \n",
       "2       305.0      67078  美丽湾国际公寓   2室1厅   45.47           北         其他   \n",
       "3       500.0      78004   向南瑞峰花园   3室1厅   64.10           西         精装   \n",
       "4       445.0      62047      海典居   2室2厅   71.72           东         其他   \n",
       "\n",
       "  elevator  area height  year buildtype  follow  \n",
       "0      有电梯    蛇口      高  2003      板塔结合      23  \n",
       "1      有电梯  南山中心      低  2001      板塔结合      95  \n",
       "2      有电梯  南山中心      高  2007        塔楼      72  \n",
       "3      有电梯  南山中心      低  2011      板塔结合      82  \n",
       "4      有电梯  南山中心      中  1999      板塔结合      33  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "house_nanshan = pd.read_excel('house_nanshan.xls', index_col=None)\n",
    "house_nanshan.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>totalprice</th>\n",
       "      <th>unitprice</th>\n",
       "      <th>position</th>\n",
       "      <th>rooms</th>\n",
       "      <th>size</th>\n",
       "      <th>orientation</th>\n",
       "      <th>decoration</th>\n",
       "      <th>elevator</th>\n",
       "      <th>area</th>\n",
       "      <th>height</th>\n",
       "      <th>year</th>\n",
       "      <th>buildtype</th>\n",
       "      <th>follow</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>420.0</td>\n",
       "      <td>47340</td>\n",
       "      <td>中海半山溪谷花园</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>88.72</td>\n",
       "      <td>西北</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>盐田港</td>\n",
       "      <td>中</td>\n",
       "      <td>2008</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>480.0</td>\n",
       "      <td>44396</td>\n",
       "      <td>中海半山溪谷花园</td>\n",
       "      <td>4室2厅</td>\n",
       "      <td>108.12</td>\n",
       "      <td>东南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>盐田港</td>\n",
       "      <td>高</td>\n",
       "      <td>2008</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>810.0</td>\n",
       "      <td>54130</td>\n",
       "      <td>海山道1号</td>\n",
       "      <td>4室2厅</td>\n",
       "      <td>149.64</td>\n",
       "      <td>东南</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>沙头角</td>\n",
       "      <td>低</td>\n",
       "      <td>2011</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>190.0</td>\n",
       "      <td>36539</td>\n",
       "      <td>金水湾御园</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>52.00</td>\n",
       "      <td>西北</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>盐田港</td>\n",
       "      <td>高</td>\n",
       "      <td>2008</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>153.0</td>\n",
       "      <td>41644</td>\n",
       "      <td>福苑</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>36.74</td>\n",
       "      <td>西北</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>沙头角</td>\n",
       "      <td>高</td>\n",
       "      <td>2001</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   totalprice  unitprice   position rooms    size orientation decoration  \\\n",
       "0       420.0      47340  中海半山溪谷花园   3室2厅   88.72          西北         精装   \n",
       "1       480.0      44396  中海半山溪谷花园   4室2厅  108.12          东南         精装   \n",
       "2       810.0      54130     海山道1号   4室2厅  149.64          东南         其他   \n",
       "3       190.0      36539     金水湾御园   2室1厅   52.00          西北         其他   \n",
       "4       153.0      41644        福苑   1室1厅   36.74          西北         其他   \n",
       "\n",
       "  elevator area height  year buildtype  follow  \n",
       "0      有电梯  盐田港      中  2008      板塔结合     104  \n",
       "1      有电梯  盐田港      高  2008      板塔结合      39  \n",
       "2      有电梯  沙头角      低  2011        塔楼      19  \n",
       "3      有电梯  盐田港      高  2008        塔楼     194  \n",
       "4      有电梯  沙头角      高  2001      板塔结合      24  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "house_yantian = pd.read_excel('house_yantian.xls', index_col=None)\n",
    "house_yantian.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "house_baoan['city'] = '宝安'\n",
    "house_futian['city'] = '福田'\n",
    "house_longgang['city'] = '龙岗'\n",
    "house_longhua['city'] = '龙华'\n",
    "house_luohu['city'] = '罗湖'\n",
    "house_nanshan['city'] = '南山'\n",
    "house_yantian['city'] = '盐田'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>totalprice</th>\n",
       "      <th>unitprice</th>\n",
       "      <th>position</th>\n",
       "      <th>rooms</th>\n",
       "      <th>size</th>\n",
       "      <th>orientation</th>\n",
       "      <th>decoration</th>\n",
       "      <th>elevator</th>\n",
       "      <th>area</th>\n",
       "      <th>height</th>\n",
       "      <th>year</th>\n",
       "      <th>buildtype</th>\n",
       "      <th>follow</th>\n",
       "      <th>city</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>420.0</td>\n",
       "      <td>47340</td>\n",
       "      <td>中海半山溪谷花园</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>88.72</td>\n",
       "      <td>西北</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>盐田港</td>\n",
       "      <td>中</td>\n",
       "      <td>2008</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>104</td>\n",
       "      <td>盐田</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>480.0</td>\n",
       "      <td>44396</td>\n",
       "      <td>中海半山溪谷花园</td>\n",
       "      <td>4室2厅</td>\n",
       "      <td>108.12</td>\n",
       "      <td>东南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>盐田港</td>\n",
       "      <td>高</td>\n",
       "      <td>2008</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>39</td>\n",
       "      <td>盐田</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>810.0</td>\n",
       "      <td>54130</td>\n",
       "      <td>海山道1号</td>\n",
       "      <td>4室2厅</td>\n",
       "      <td>149.64</td>\n",
       "      <td>东南</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>沙头角</td>\n",
       "      <td>低</td>\n",
       "      <td>2011</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>19</td>\n",
       "      <td>盐田</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>190.0</td>\n",
       "      <td>36539</td>\n",
       "      <td>金水湾御园</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>52.00</td>\n",
       "      <td>西北</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>盐田港</td>\n",
       "      <td>高</td>\n",
       "      <td>2008</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>194</td>\n",
       "      <td>盐田</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>153.0</td>\n",
       "      <td>41644</td>\n",
       "      <td>福苑</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>36.74</td>\n",
       "      <td>西北</td>\n",
       "      <td>其他</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>沙头角</td>\n",
       "      <td>高</td>\n",
       "      <td>2001</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>24</td>\n",
       "      <td>盐田</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   totalprice  unitprice   position rooms    size orientation decoration  \\\n",
       "0       420.0      47340  中海半山溪谷花园   3室2厅   88.72          西北         精装   \n",
       "1       480.0      44396  中海半山溪谷花园   4室2厅  108.12          东南         精装   \n",
       "2       810.0      54130     海山道1号   4室2厅  149.64          东南         其他   \n",
       "3       190.0      36539     金水湾御园   2室1厅   52.00          西北         其他   \n",
       "4       153.0      41644        福苑   1室1厅   36.74          西北         其他   \n",
       "\n",
       "  elevator area height  year buildtype  follow city  \n",
       "0      有电梯  盐田港      中  2008      板塔结合     104   盐田  \n",
       "1      有电梯  盐田港      高  2008      板塔结合      39   盐田  \n",
       "2      有电梯  沙头角      低  2011        塔楼      19   盐田  \n",
       "3      有电梯  盐田港      高  2008        塔楼     194   盐田  \n",
       "4      有电梯  沙头角      高  2001      板塔结合      24   盐田  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>totalprice</th>\n",
       "      <th>unitprice</th>\n",
       "      <th>position</th>\n",
       "      <th>rooms</th>\n",
       "      <th>size</th>\n",
       "      <th>orientation</th>\n",
       "      <th>decoration</th>\n",
       "      <th>elevator</th>\n",
       "      <th>area</th>\n",
       "      <th>height</th>\n",
       "      <th>year</th>\n",
       "      <th>buildtype</th>\n",
       "      <th>follow</th>\n",
       "      <th>city</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>920.0</td>\n",
       "      <td>77188</td>\n",
       "      <td>天悦龙庭二期</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>119.19</td>\n",
       "      <td>西南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>宝安中心</td>\n",
       "      <td>中</td>\n",
       "      <td>2005</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>13</td>\n",
       "      <td>宝安</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>340.0</td>\n",
       "      <td>51909</td>\n",
       "      <td>大益广场</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>65.50</td>\n",
       "      <td>西南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>西乡</td>\n",
       "      <td>低</td>\n",
       "      <td>2002</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>160</td>\n",
       "      <td>宝安</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>660.0</td>\n",
       "      <td>73884</td>\n",
       "      <td>中熙香缇湾</td>\n",
       "      <td>4室2厅</td>\n",
       "      <td>89.33</td>\n",
       "      <td>西南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>西乡</td>\n",
       "      <td>中</td>\n",
       "      <td>2009</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>226</td>\n",
       "      <td>宝安</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1150.0</td>\n",
       "      <td>76657</td>\n",
       "      <td>深业新岸线三期</td>\n",
       "      <td>4室1厅</td>\n",
       "      <td>150.02</td>\n",
       "      <td>东南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>宝安中心</td>\n",
       "      <td>中</td>\n",
       "      <td>2008</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>29</td>\n",
       "      <td>宝安</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>570.0</td>\n",
       "      <td>52127</td>\n",
       "      <td>碧海富通城一期</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>109.35</td>\n",
       "      <td>南</td>\n",
       "      <td>精装</td>\n",
       "      <td>有电梯</td>\n",
       "      <td>碧海</td>\n",
       "      <td>中</td>\n",
       "      <td>2006</td>\n",
       "      <td>板塔结合</td>\n",
       "      <td>54</td>\n",
       "      <td>宝安</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   totalprice  unitprice  position rooms    size orientation decoration  \\\n",
       "0       920.0      77188   天悦龙庭二期   3室2厅  119.19          西南         精装   \n",
       "1       340.0      51909     大益广场   2室2厅   65.50          西南         精装   \n",
       "2       660.0      73884    中熙香缇湾   4室2厅   89.33          西南         精装   \n",
       "3      1150.0      76657  深业新岸线三期   4室1厅  150.02          东南         精装   \n",
       "4       570.0      52127  碧海富通城一期   3室2厅  109.35           南         精装   \n",
       "\n",
       "  elevator  area height  year buildtype  follow city  \n",
       "0      有电梯  宝安中心      中  2005        塔楼      13   宝安  \n",
       "1      有电梯    西乡      低  2002      板塔结合     160   宝安  \n",
       "2      有电梯    西乡      中  2009      板塔结合     226   宝安  \n",
       "3      有电梯  宝安中心      中  2008        塔楼      29   宝安  \n",
       "4      有电梯    碧海      中  2006      板塔结合      54   宝安  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "house = pd.concat([house_baoan,house_futian,house_longgang,house_longhua,house_luohu,house_nanshan,house_yantian],axis=0,ignore_index=True)\n",
    "house.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "house.to_excel('house.xls',sheet_name='biubiu')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
